leetcode-sql/medium/1699. Number of Calls Between Two Persons.sql at main · cM2908/leetcode-sql · GitHub

Name: leetcode-sql/medium/1699. Number of Calls Between Two Persons.sql at main · cM2908/leetcode-sql · GitHub
Rating: 4.7 (9959 reviews)
1
2
3
4
5
6
7
8
9
10
11
WITH calls AS (
SELECT from_id,to_id,duration
FROM calls_1699
UNION ALL
SELECT to_id,from_id,duration
FROM calls_1699
)
SELECT from_id,to_id,COUNT(*) AS call_count,SUM(duration) AS total_duration
FROM calls
WHERE from_id<to_id
GROUP BY from_id,to_id;